# PyMSQL创建数据库连接
from pymysql import Connection

conn = None
try:
    # 创建数据库连接
    conn = Connection(
        host='localhost',  # 主机地址
        port=3306,  # 端口
        user='root',  # 用户名
        password='root',  # 密码
        database='learn_pymysql',  # 数据库
        autocommit=True  # 配置自动提交
    )
    # 获取游标
    cursor = conn.cursor()

    sql = "insert into `regions`(`region_id`,`region_name`) values (1,'Europe'),(2,'Americas'),(3,'Asia'),(4,'Middle East and Africa');"

    # 使用游标对象执行sql
    cursor.execute(sql)

    # 提交
    # conn.commit()  # 可在connection中配置自动提交
except Exception as e:
    print("发生异常：", e)
finally:
    if conn:
        # 关闭连接
        conn.close()